package com.hns.its.dao;

import com.hns.its.domain.ItsBaseShippingScheduleEntity;
import com.hns.its.persistence.jpa.GenericRepository;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

/**
 * 船期DAO
 */
public interface IItsBaseShippingScheduleDao extends JpaRepository<ItsBaseShippingScheduleEntity, String>, JpaSpecificationExecutor<ItsBaseShippingScheduleEntity> {

	@Query("FROM ItsBaseShippingScheduleEntity WHERE shipName = ?1 and shipTimer = ?2 and logisticId is null")
	public ItsBaseShippingScheduleEntity getShippingSchedule(String shipName, String shipTimer);
	
}
